Calculation Engine Samples |
Fastest and most complete Excel compatible calculations without Excel |
|
 |
The true power of SpreadsheetGear for .NET is realized when using its superior Microsoft
Excel compatible calculation engine. Its unmatched performance and accuracy provide
a competitive advantage to data critical Windows Forms and ASP.NET applications.
The following samples show various ways to utilize the spreadsheet calculation engine
to manipulate data in a windows forms project. These examples are easily adaptable
to many Microsoft .NET Framework solutions. |
|
Formula Evaluation |
Demonstrates evaluating a single Excel compatible formula entered into a windows
form. |
|
Simple Loan Calculator |
Demonstrates calculating a loan payment based on input from a windows form. By using
this design pattern, you can easily deploy complex numeric, financial and statistics
calculators which call on the full power of SpreadsheetGear for .NET's Microsoft
Excel compatible calculation capabilities. |
|
Amortization Calculator |
Extends the Simple Loan Calculator with an amortization table which is displayed
in a WorkbookView control. Of particular interest is the use of the defined name,
AmortizationTableForNPer, which uses the OFFSET() worksheet function to return a
dynamically sized range. |
|
Custom Functions |
Demonstrates creating your own custom functions in the Microsoft .NET Framework
and adding them to a workbook set. The worksheet formulas which utilize these custom
functions are compatible with Microsoft Excel worksheet formulas which utilize VBA
or XLL custom functions. |
|